|
|
|
|
|
|
|

SELECT S_Articles.UID AS UID,
S_Articles.Modified AS Modified,
S_Articles.Name AS Name,
S_Articles.PreTitle AS PreTitle,
S_Articles.Description AS Description,
S_ItemsCategories.ItemsCategoriesModeID AS ItemsCategoriesModeID,
S_Articles.HTML AS HTML, CASE
WHEN NOT S_Articles.HTML IS NULL AND N''>'' THEN
dbo.S_MarkPhrases((SELECT Text FROM dbo.S_RemoveTags(S_Articles.HTML) FOR XML RAW('a')), N'', '', '')
ELSE NULL END AS MarkedHTML,
[dbo].S_GetItemAttributesList(3, S_Articles.UID) AS AttributesList, CASE WHEN TitleLogoPictures.FileName>'' THEN '../UserFiles450/'+TitleLogoPictures.FileName ELSE '' END AS TitleLogoPictureFileName
FROM S_Articles
INNER JOIN S_ItemsCategories ON (S_ItemsCategories.ItemTypeID=3 AND S_Articles.UID=S_ItemsCategories.ItemUID)
LEFT JOIN S_Pictures AS TitleLogoPictures ON S_Articles.TitleLogoPictureUID=TitleLogoPictures.UID
WHERE S_ItemsCategories.ShopID=450
AND S_Articles.IsActive <> 0
AND S_Articles.ShopID = 450 AND S_ItemsCategories.CategoryUID = '{6C787B71-DAFF-4BA4-81F6-BD86DC91D2D4}' ORDER BY S_ItemsCategories.[Index]
|
» צור קשר עם התמיכה הטכנית
|
|
» אפשרויות תמיכה נוספות |
|
|
|
טלפון חינם לקריאת שרות 014-800-277-40950
|
|
|
|
|
|
|
|